'use strict';
module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('enterprises', {
      key:{
        allowNull:true,
        type: Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement: true
      },
      id: {
        allowNull: false,
        type: Sequelize.STRING
      },
      enterpriseName: {
        type: Sequelize.STRING
      },
      status: {
        type: Sequelize.STRING
      },
      id: {
        type: Sequelize.STRING
      },
      province: {
        type: Sequelize.STRING
      },
      city: {
        type: Sequelize.STRING
      },
      area: {
        type: Sequelize.STRING
      },
      legalRep: {
        type: Sequelize.STRING
      },
      regCapital: {
        type: Sequelize.STRING
      },
      estiblishTime: {
        type: Sequelize.STRING
      },
      historyName: {
        type: Sequelize.STRING
      },
      industry: {
        type: Sequelize.STRING
      },
      companyOrgType: {
        type: Sequelize.STRING
      },
      socialStaffNum: {
        type: Sequelize.STRING
      },
      businessScope: {
        type: Sequelize.STRING
      },
      regLocation: {
        type: Sequelize.STRING
      },
      newLocation: {
        type: Sequelize.STRING
      },
      email: {
        type: Sequelize.STRING
      },
      certEmail: {
        type: Sequelize.STRING
      },
      website: {
        type: Sequelize.STRING
      },
      phone1: {
        type: Sequelize.STRING
      },
      phone2: {
        type: Sequelize.STRING
      },
      phone3: {
        type: Sequelize.STRING
      },
      phone4: {
        type: Sequelize.STRING
      },
      phone5: {
        type: Sequelize.STRING
      },
      phone6: {
        type: Sequelize.STRING
      },
      phone7: {
        type: Sequelize.STRING
      },
      phone8: {
        type: Sequelize.STRING
      },
      phone9: {
        type: Sequelize.STRING
      },
      phone10: {
        type: Sequelize.STRING
      },
      webemail:{
        type: Sequelize.STRING
      },
      webphone:{
        type: Sequelize.STRING
      },
      webaddress:{
        type: Sequelize.STRING
      },
      isget:{
        type: Sequelize.STRING
      },
      remark:{
        type: Sequelize.STRING
      },
      result:{
        type: Sequelize.STRING
      }
    });
  },
  async down(queryInterface, Sequelize) {
    await queryInterface.dropTable('enterprises');
  }
};